How to: Use AutoFilter.
Solution:
Select 'Filter' from the 'Data' menu and select 'AutoFilter'. Click the down arrow button in the column where filtering criteria should be entered and select the desired filtering option from the displayed drop-down list.
1) Select any cell in a list.
2) Select the 'Data' menu and select 'Filter'. (A submenu appears.)
the Filter submenu
3) Select 'AutoFilter' from the submenu. (The cells at the top row of the list become drop-down lists.)
NOTE: The 'AutoFilter' command in the submenu should not have a check mark on the left. If it does, select 'AutoFilter' to uncheck it first. Then start from Step 2) again.
4) Click down arrow button in the column where filtering criteria should be typed. (A drop-down list appears.)
the filtering drop-down lists
5) Select the desired filtering option from the drop-down list:
a) Select '(All)' to display all records.
b) Select '(Top Ten...)' to display a specified number of records, either by percent or by number, from the top or bottom of the list.
NOTE: '(Top Ten...)' works only for columns containing numbers.
c) Select '(Custom...)' to create customized filtering criteria in the 'Custom Filter' dialog box.
d) Select an exact value to display only records with that value.
NOTE: Use the '(Custom...)' option to select more than one value.
e) Select '(Blanks)' to display all records without any data in this field.
f) Select '(Non-Blanks)' to display all records that contain data in this field.
